<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html";>
<meta name="keywords" content="DeZign for Databases - HTML Report">
<meta name="author" content="Datanamic - www.datanamic.com">
<title>DeZign for Databases V4 - HTML Report</title>
<link rel="stylesheet" type="text/css" media="screen,print" href="dezign.css" title="report">
</head>
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10">
<div class="top">Logical model</div>
<ul id="menu">
<li><a href="index.html">Project details</a></li>
<li><a href="erdiagram.html">ER diagram</a></li>
<li><a href="entl.html">Entities</a></li>
<li><a href="attrl.html">Attributes</a></li>
<li><a href="rell.html">Relationships</a></li>
<li><a href="doml.html">Domains</a></li>
<li><a href="viewl.html">Views</a></li>
<li><a href="procl.html">Procedures</a></li>
</ul>
<div class="row">
<div class="tab"><a href="entl.html">List of entities</a></div>
<div class="activetab">Entity details</div>
</div>
<table width=90% border=0 cellSpacing=0 cellPadding=0 class="chapter">
<tr>
<td class="left" valign=top>
<ul id="objectbrowser">
<li><a href="#AdvertizingMethods">AdvertizingMethods</a></li>
<li><a href="#ApgEmailTemplates">ApgEmailTemplates</a></li>
<li><a href="#APGs">APGs</a></li>
<li><a href="#Appointments">Appointments</a></li>
<li><a href="#ASPs">ASPs</a></li>
<li><a href="#Campaign">Campaign</a></li>
<li><a href="#Clicks">Clicks</a></li>
<li><a href="#Contacts">Contacts</a></li>
<li><a href="#Coupons">Coupons</a></li>
<li><a href="#Deposits">Deposits</a></li>
<li><a href="#Emails">Emails</a></li>
<li><a href="#EmailTemplate">EmailTemplate</a></li>
<li><a href="#EventParticipants">EventParticipants</a></li>
<li><a href="#Events">Events</a></li>
<li><a href="#Leads">Leads</a></li>
<li><a href="#Locations">Locations</a></li>
<li><a href="#MailingLists">MailingLists</a></li>
<li><a href="#Markets">Markets</a></li>
<li><a href="#Packages">Packages</a></li>
<li><a href="#RCs">RCs</a></li>
<li><a href="#RC_Region">RC_Region</a></li>
<li><a href="#Redemptions">Redemptions</a></li>
<li><a href="#Referrals">Referrals</a></li>
<li><a href="#SonsorRolodex">SonsorRolodex</a></li>
<li><a href="#Sponsors">Sponsors</a></li>
<li><a href="#Sponsors_AdvertizingMethods">Sponsors_AdvertizingMethods</a></li>
<li><a href="#Sponsors_Markets">Sponsors_Markets</a></li>
<li><a href="#Sponsors_Packages">Sponsors_Packages</a></li>
<li><a href="#Statements">Statements</a></li>
<li><a href="#SynergesticMarkets">SynergesticMarkets</a></li>
<li><a href="#WebinarParticipants">WebinarParticipants</a></li>
<li><a href="#Webinars">Webinars</a></li>
<li><a href="#ZIP">ZIP</a></li>
</ul>
</td>
<td class="right" valign=top>
<A NAME="AdvertizingMethods"></A>
<div class="objectname">Entity: AdvertizingMethods</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">These are the various advertizing methods considered when performing the advertizing analysis for the sponsor.  A seperate many-to-many table provide the mapping between this table and the sponsors table.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_AdvertizingMethods</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#advertizing_method_id">advertizing_method_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The unique identifier for the advertising method.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name">name</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The names of the advertising method, as it appears on the advertising analusos screen.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">AdvertizingMethods_Sponsors_AdvertizingMethods</td><td class="fielddata">Identifying</td><td class="fielddata">AdvertizingMethods</td><td class="fielddata">Sponsors_AdvertizingMethods</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_AdvertizingMethods_1</td><td class="fielddata">advertizing_method_id</td><td class="fielddata"></td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">name</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">advertizing_method_id</td></tr>
<tr><td class="fielddata">PK_AdvertizingMethods</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (advertizing_method_id)</td></tr>
</table>
<A NAME="ApgEmailTemplates"></A>
<div class="objectname">Entity: ApgEmailTemplates</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master repository of all email templates used by sponsors to send promo emails.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_ApgEmailTemplates</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#template_id">template_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">A unique identifier of this templates.  Each APG is associated exactly one template.  Each campaign email is associated with one template.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#photo_image_URL_str">photo_image_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A URL pointing to the sponsor's representative photo.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_image_URL_str">header_image_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A URL pointing to the email header image.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_background_color_str">header_background_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata">The background color becomes visible when the alpha of the header image is <100%.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_alpha_pct">header_alpha_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The alpha percent used for the header image.  Alpha=100% implies the background color is not visible.  Alpha=0% means the image is not visible and only the background color is visible.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#business_name_text_color_str">business_name_text_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata">The color of the business name in 6 hex digits.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#business_name_str">business_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The name of the business brand as it is to appear on the header.  This could be different from the company name.  When creating a new template, the default value is derived from the sponsor's company name.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#slogan_text_color_str">slogan_text_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata">The color of the business name in 6 hex digits.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#slogan_line1_str">slogan_line1_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The first line of the slogan printed over the header.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#slogan_line2_str">slogan_line2_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The second line of the slogan printed over the header.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_phone_str">referral_phone_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">This is typically a toll free number used to accept anonymous inquiries.  It is also the phone number used when selecting the 'phone' icon under the photo.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_email_str">referral_email_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">This is typically a customer service or sales email used to accept anonymous inquiries.  It is also the email used when selecting the 'email' icon under the photo.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_chat_id_str">referral_chat_id_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">This is typically a customer service or sales skype chad id used to accept anonymous inquiries.  It is also the chat id used when selecting the 'smiley' icon under the photo.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_link_URL_str">referral_link_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL specified for the referral link.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_link_text_str">referral_link_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">This is the text specified for the referral link.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_URL_str">optional_link_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL specified for the optional link.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_text_str">optional_link_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">This is the text specified for the optional link.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#audio_file_URL_str">audio_file_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The URL to the testimonial audio.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#banner_ad_business_name_str">banner_ad_business_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#banner_ad_business_name_color_str">banner_ad_business_name_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#banner_ad_discount_pct">banner_ad_discount_pct</A></td><td class="fielddata">TINYINT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#banner_ad_discount_color_str">banner_ad_discount_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ApgEmailTemplates_APGs</td><td class="fielddata">Non Identifying</td><td class="fielddata">ApgEmailTemplates</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ApgEmailTemplates_Campaign</td><td class="fielddata">Non Identifying</td><td class="fielddata">ApgEmailTemplates</td><td class="fielddata">Campaign</td><td class="fielddata">One Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_ApgEmailTemplates_1</td><td class="fielddata">template_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">template_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">photo_image_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_image_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_background_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_alpha_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">business_name_text_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">business_name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">slogan_text_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">slogan_line1_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">slogan_line2_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_phone_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_email_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_chat_id_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_link_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_link_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_URL_str</td></tr>
<tr><td class="fielddata">PK_ApgEmailTemplates</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (template_id)</td></tr>
</table>
<A NAME="APGs"></A>
<div class="objectname">Entity: APGs</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all APGs.  Each APG is defined as a one-to-many mapping of Sponsors to CAPs.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_APGs</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#apg_id">apg_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name">name</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The name of the APG used in case a sponsor has multiple APGs.  Users cannot edit those names.  These names are of the form "APG #", e.g., "APG 1","APG 2","APG 3".</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap1_id">cap1_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap2_id">cap2_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap3_id">cap3_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap4_id">cap4_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap5_id">cap5_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap6_id">cap6_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap7_id">cap7_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap8_id">cap8_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cap9_id">cap9_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#template_id">template_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The email template used for this APG.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ApgEmailTemplates_APGs</td><td class="fielddata">Non Identifying</td><td class="fielddata">ApgEmailTemplates</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APGs_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">APGs</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap1</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap2</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap3</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap4</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap5</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap6</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap7</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap8</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap9</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Sponsor</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_APGs_1</td><td class="fielddata">apg_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_APGs_2</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">template_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">apg_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata">ApgEmailTemplates_APGs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (template_id) REFERENCES ApgEmailTemplates(template_id)</td></tr>
<tr><td class="fielddata">APG_Cap1</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap1_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap2</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap2_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap3</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap3_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap4</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap4_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap5</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap5_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap6</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap6_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap7</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap7_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap8</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap8_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Cap9</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cap9_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">APG_Sponsor</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
<tr><td class="fielddata">PK_APGs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (apg_id)</td></tr>
</table>
<A NAME="Appointments"></A>
<div class="objectname">Entity: Appointments</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">The purpose of the meeting.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Appointments</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#appointment_id">appointment_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The unique identifier for this appointment.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#purpose_enm">purpose_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">The purpose of the meeting.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#action_enm">action_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">An indication to the ASP (or the RC) what is the action that needs to be performed on this meeting with this prospect.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#prospect_type_enm">prospect_type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">The prospect can be either Sponsor, CorpSponsor or CAP.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#lead_type_enm">lead_type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">An indication whether this is an internal or external leads.  The more internal lead are generated compared to external leads, the better the APG Network referral system works for this RC.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_method">referral_method</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">The method, and who, referred this prospect.  </td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#rc_id">rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The RC for whom this meeting is scheduled.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#asp_id">asp_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The ASP scheduling this meeting.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#prospect_contacts_id">prospect_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">Information  about the prospect with whom the RC meets.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#meeting_rating_enm">meeting_rating_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">An indication of how well this meeting went.  If a deal was closed, this value can be either effective, commendable or exemplary.  If maxumim packages were sold, this is exemplary.  If the meeting took place and rescheduled, but a followup is expected, the rating is'marginal'.  If no sale was made and the prospect would not agree for a followup, then the rating is 'unacceptable'.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#notes_str">notes_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#driving_directions_URL_str">driving_directions_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A URL to allow the RC to generate the driving directions to this location.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ASPs_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">ASPs</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">RCs_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Appointments_1</td><td class="fielddata">appointment_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Appointments_2</td><td class="fielddata">asp_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Appointments_3</td><td class="fielddata">rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">driving_directions_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">appointment_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">purpose_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">action_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">prospect_type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">lead_type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_method</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rc_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">asp_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">prospect_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">meeting_rating_enm</td></tr>
<tr><td class="fielddata">ASPs_Appointments</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (asp_id) REFERENCES ASPs(asp_id)</td></tr>
<tr><td class="fielddata">Contacts_Appointments</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (prospect_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Appointments</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (appointment_id)</td></tr>
<tr><td class="fielddata">RCs_Appointments</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (rc_id) REFERENCES RCs(rc_id)</td></tr>
</table>
<A NAME="ASPs"></A>
<div class="objectname">Entity: ASPs</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master list of all ASPs doing business with the APG network.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_ASPs</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#asp_id">asp_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#first_rc_id">first_rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The first of three RCs this ASP is scheduling appointments for.  At least one RC is required.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#first_rc_assigned_dt">first_rc_assigned_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">No</td><td class="fielddata">The date at which the first RC was assigned to this ASP.  This information is used for calculating the number of deals closed and the cummulative bonuses.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#second_rc_id">second_rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The second of three RCs this ASP is scheduling appointments for.  This is an optional RC because only one RC is required.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#second_rc_assigned_dt">second_rc_assigned_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">No</td><td class="fielddata">The date at which the second RC was assigned to this ASP.  This information is used for calculating the number of deals closed and the cummulative bonuses.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#third_rc_id">third_rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The third of three RCs this ASP is scheduling appointments for.  This is an optional RC because only one RC is required.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#third_rc_assigned_dt">third_rc_assigned_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">No</td><td class="fielddata">The date at which the third RC was assigned to this ASP.  This information is used for calculating the number of deals closed and the cummulative bonuses.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#appointment_compensation_amt">appointment_compensation_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The compensation this ASP gets for each appointment set.  A rescheduled appointment is regarded as a new appointment for compensation.  A canceled appointment is compensated for.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commussion_rate_pct">commussion_rate_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The percent commision that the ASP recieves from a deal the RC closed.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#period_cutoff_day_of_month_int">period_cutoff_day_of_month_int</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The day of the month (e.g., 20th) by which commission and bonus amounts accumulate.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commission_paid_within_days_cnt">commission_paid_within_days_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of days after the cutoff by when the payment is to be rendered/</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sponsor_cnt">sponsor_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#CAP_cnt">CAP_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sys_sales_amt">sys_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#consulting_sales_amt">consulting_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_consulting_sales_amt">monthly_consulting_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commulative_monthly_user_fees_amt">commulative_monthly_user_fees_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commulative_bonus_balance_amt">commulative_bonus_balance_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#ytd_comission_paid_amt">ytd_comission_paid_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#open_appointments_cnt">open_appointments_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#on_hold_appointments_cnt">on_hold_appointments_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#running_appts_weekly_cnt">running_appts_weekly_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#appointments_set_cnt">appointments_set_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#apppointment_rate_amt">apppointment_rate_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sppointment_comission_amt">sppointment_comission_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_compensation_amt">total_compensation_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#RC_sales_amt">RC_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ASPs_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">ASPs</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ASP_first_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ASP_second_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ASP_third_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_ASPs</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_ASPs_1</td><td class="fielddata">asp_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_ASPs_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_ASPs_3</td><td class="fielddata">first_rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_ASPs_4</td><td class="fielddata">second_rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_ASPs_5</td><td class="fielddata">third_rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">commission_paid_within_days_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">asp_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">first_rc_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">appointment_compensation_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">commussion_rate_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">period_cutoff_day_of_month_int</td></tr>
<tr><td class="fielddata">ASP_first_RC</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (first_rc_id) REFERENCES RCs(rc_id)</td></tr>
<tr><td class="fielddata">ASP_second_RC</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (second_rc_id) REFERENCES RCs(rc_id)</td></tr>
<tr><td class="fielddata">ASP_third_RC</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (third_rc_id) REFERENCES RCs(rc_id)</td></tr>
<tr><td class="fielddata">Contacts_ASPs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_ASPs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (asp_id)</td></tr>
</table>
<A NAME="Campaign"></A>
<div class="objectname">Entity: Campaign</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master repository of all email campaigns sent out by the system,</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Campaign</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#campaign_id">campaign_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#from_str">from_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The email address populated in the 'from' field.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#to_mailing_list_id">to_mailing_list_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#template_id">template_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The specific template used for this campaign.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#subject_str">subject_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#body_HTML_txt">body_HTML_txt</A></td><td class="fielddata">TEXT</td><td class="fielddata">Yes</td><td class="fielddata">The body of the email is specified in HTML format, edited using the Flex RichTextEditor.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sent_dtb">sent_dtb</A></td><td class="fielddata">DATETIME</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_emails_sent_cnt">total_emails_sent_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_emails_opened_cnt">total_emails_opened_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_unsubscribers_cnt">total_unsubscribers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_counces_cnt">total_counces_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_link_clicks_cnt">referral_link_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_clicks_cnt">optional_link_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#banner_ads_clicks_cnt">banner_ads_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#audio_clicks_cnt">audio_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#coupons_clicks_cnt">coupons_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#coupons_audio_clicks_cnt">coupons_audio_clicks_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ApgEmailTemplates_Campaign</td><td class="fielddata">Non Identifying</td><td class="fielddata">ApgEmailTemplates</td><td class="fielddata">Campaign</td><td class="fielddata">One Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Campaign_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Campaign</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">MailingLists_Campaign</td><td class="fielddata">Non Identifying</td><td class="fielddata">MailingLists</td><td class="fielddata">Campaign</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Campaign_1</td><td class="fielddata">campaign_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Campaign_2</td><td class="fielddata">template_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coupons_audio_clicks_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">campaign_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">from_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">to_mailing_list_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">template_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">subject_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">body_HTML_txt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sent_dtb</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_emails_sent_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_emails_opened_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_unsubscribers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_counces_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_link_clicks_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_clicks_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">banner_ads_clicks_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">audio_clicks_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coupons_clicks_cnt</td></tr>
<tr><td class="fielddata">ApgEmailTemplates_Campaign</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (template_id) REFERENCES ApgEmailTemplates(template_id)</td></tr>
<tr><td class="fielddata">MailingLists_Campaign</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (to_mailing_list_id) REFERENCES MailingLists(mailing_list_id)</td></tr>
<tr><td class="fielddata">PK_Campaign</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (campaign_id)</td></tr>
</table>
<A NAME="Clicks"></A>
<div class="objectname">Entity: Clicks</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This table is used to track ad statistics, clicks etc.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Clicks</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#click_id">click_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">A unique identifier of all clicks being tracked by the system.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#URL">URL</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL that was clicked.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_cap_contacts_id">sponsor_cap_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The sponsor to which this clicks needs to be credited.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#coupon_id">coupon_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The coupon that was clicked on, when applicable.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#apg_id">apg_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The APG to which this click is credited, when applicable.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#campaign_id">campaign_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The campaign to which this click is attributed, when applicable.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">APGs_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">APGs</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Campaign_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Campaign</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Coupons_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Coupons</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_cap_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">click_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">URL</td></tr>
<tr><td class="fielddata">APGs_Clicks</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (apg_id) REFERENCES APGs(apg_id)</td></tr>
<tr><td class="fielddata">Campaign_Clicks</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (campaign_id) REFERENCES Campaign(campaign_id)</td></tr>
<tr><td class="fielddata">Contacts_Clicks</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_cap_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Coupons_Clicks</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (coupon_id) REFERENCES Coupons(coupon_id)</td></tr>
<tr><td class="fielddata">PK_Clicks</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (click_id)</td></tr>
</table>
<A NAME="Contacts"></A>
<div class="objectname">Entity: Contacts</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the repository of all individuals with which the system interacts.  </td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Contacts</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">A unique contact identifier.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#first_name_str">first_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The individual's first name; this is a required field.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#nick_name_str">nick_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The individual's nick name; this is an optional field.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#last_name_str">last_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The individual's last name; this is a required field.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_method_emn">referral_method_emn</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata">The referral method by which this contact was obtained.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#login_name_str">login_name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The login assigned to this user.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#login_password_str">login_password_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The password assigned to this user.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#role_enm">role_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata">The role this individual plays; not every individual is a user of the system.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#company_str">company_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The name of the company with which the individual is affiliated or the name under which the individual is doing business.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#title_str">title_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The business title of the individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#street_address_str">street_address_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The mailing street address for the place of business of this contact.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#ZIP_code">ZIP_code</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The mailing ZIP code for the place of business of this contact.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#office_phone_str">office_phone_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata">The main line for the place of business of this contact.  This could be an international number.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#office_phone_ext_str">office_phone_ext_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata">The extantion, if any, used to reach the individual's desk.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#fax_str">fax_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata">The fax line for the place of business of this contact.  This could be an international number.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#email_str">email_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The email address for this individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#mobile_phone_str">mobile_phone_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">No</td><td class="fielddata">The personal mobile phone number of this contact.  This could be an international number.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#home_phone_str">home_phone_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The personal home phone number of this contact.  This could be an international number.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#skype_id_str">skype_id_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">This is the skype Id for this individual.  To simplify, the APG network is standardizing around Skype.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#checked_flg">checked_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">This is the checkbox value.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#notes_str">notes_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">Notes associated with this individual.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#referring_contact_id">referring_contact_id</A></td><td class="fielddata">BIGINT</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">CateringContact_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_ASPs</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Contacts</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Contacts</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Contacts</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Contacts</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Deposits</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Deposits</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Leads</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Leads</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Locations</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Locations</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_RCs</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">RCs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Redemptions</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Redemptions</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_SonsorRolodex</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">SonsorRolodex</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Sponsors</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Sponsors</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Statements</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Statements</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_WebinarParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Webinars</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Webinars</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Coordinator_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Emails_CcContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Emails_FromContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Emails_ToContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Referee_Contact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Referrals</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Referred_Contact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Referrals</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsor_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_Contacts</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Contacts</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Contacts_1</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">checked_flg</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">first_name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">last_name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">email_str</td></tr>
<tr><td class="fielddata">Contacts_Contacts</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (referring_contact_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Contacts</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (contacts_id)</td></tr>
<tr><td class="fielddata">ZIP_Contacts</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (ZIP_code) REFERENCES ZIP(ZIP_code)</td></tr>
</table>
<A NAME="Coupons"></A>
<div class="objectname">Entity: Coupons</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all eCoupons.  It include all color specification, and references to image and audio files for each coupon.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Coupons</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#coupon_id">coupon_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#value_amt">value_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The dollar value of this coupon.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#expires_dt">expires_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_image_URL_str">header_image_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL pointing to the coupon header image.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referred_by">referred_by</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_background_color_str">header_background_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_alpha_pct">header_alpha_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#title_text_str">title_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#title_color_str">title_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#title_location_x">title_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#summary_text_str">summary_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#summary_color_str">summary_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#summary_location_x">summary_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#header_location_y">header_location_y</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#body_image_URL_str">body_image_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL pointing to the coupon body image.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#offer_summary_text_str">offer_summary_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#offer_summary_color_str">offer_summary_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#offer_summary_location_x">offer_summary_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#offer_summary_location_y">offer_summary_location_y</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#disclpaimer_text_str">disclpaimer_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#disclaimer_color_str">disclaimer_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#disclaimer_location_x">disclaimer_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#closing_text_str">closing_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#closing_text_color_str">closing_text_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#closing_text_location_x">closing_text_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#expired_color_str">expired_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#expired_location_x">expired_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#body_location_y">body_location_y</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#footer_image_URL_str">footer_image_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL pointing to the coupon footer image.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#footer_background_color_str">footer_background_color_str</A></td><td class="fielddata">CHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#footer_alpha_pct">footer_alpha_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#testimonial_link_URL_str">testimonial_link_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A URL to the testimonial MP3 file.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#testimonial_link_text_str">testimonial_link_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#testimonial_link_location_x">testimonial_link_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_URL_str">optional_link_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_text_str">optional_link_text_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#optional_link_location_x">optional_link_location_x</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#footer_location_y">footer_location_y</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#audio_URL_str">audio_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A URL pointing to the testimonial MP3 file.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#listened_cnt">listened_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#printed_cnt">printed_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#redeemed_cnt">redeemed_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referred_cnt">referred_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Coupons_Clicks</td><td class="fielddata">Non Identifying</td><td class="fielddata">Coupons</td><td class="fielddata">Clicks</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Coupons_Redemptions</td><td class="fielddata">Non Identifying</td><td class="fielddata">Coupons</td><td class="fielddata">Redemptions</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Coupons</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Coupons</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Coupons_1</td><td class="fielddata">coupon_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Coupons_2</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referred_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coupon_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">value_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">expires_dt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_image_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referred_by</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_background_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_alpha_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">title_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">title_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">title_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">summary_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">summary_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">summary_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">header_location_y</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">body_image_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">offer_summary_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">offer_summary_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">offer_summary_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">offer_summary_location_y</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">disclpaimer_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">disclaimer_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">disclaimer_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">closing_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">closing_text_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">closing_text_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">expired_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">expired_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">body_location_y</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">footer_image_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">footer_background_color_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">footer_alpha_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">testimonial_link_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">testimonial_link_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">testimonial_link_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_text_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">optional_link_location_x</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">footer_location_y</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">audio_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">listened_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">printed_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">redeemed_cnt</td></tr>
<tr><td class="fielddata">PK_Coupons</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (coupon_id)</td></tr>
<tr><td class="fielddata">Sponsors_Coupons</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
</table>
<A NAME="Deposits"></A>
<div class="objectname">Entity: Deposits</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master repository of all deposits related to the APG Network.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Deposits</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#deposit_id">deposit_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#deposit_amount_amt">deposit_amount_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The amount deposited.  When a rebate is applied, a new 'artificial' deposit is created with a *negative* amount.  This renders the sum of deposits directly applicable towards the account ballance.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#deposit_date_amt">deposit_date_amt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#card_holder_str">card_holder_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#credit_card_type_enm">credit_card_type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#card_number">card_number</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cvv2">cvv2</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#expiration_date_dt">expiration_date_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#billing_street_address_str">billing_street_address_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The billing street address is different from the contact's address.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The individual making this deposit.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#billing_ZIP_code">billing_ZIP_code</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">Billing ZIP code if different from the contact's ZIP code.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Deposits</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Deposits</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Deposits_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Deposits</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Deposits_WebinarParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Deposits</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_Deposits</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Deposits</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Deposits_1</td><td class="fielddata">deposit_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Deposits_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Deposits_3</td><td class="fielddata">card_number</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">deposit_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">deposit_amount_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">deposit_date_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">card_holder_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">credit_card_type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">card_number</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">cvv2</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">expiration_date_dt</td></tr>
<tr><td class="fielddata">Contacts_Deposits</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Deposits</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (deposit_id)</td></tr>
<tr><td class="fielddata">ZIP_Deposits</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (billing_ZIP_code) REFERENCES ZIP(ZIP_code)</td></tr>
</table>
<A NAME="Emails"></A>
<div class="objectname">Entity: Emails</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a repository of all emails sent out by the system.  This excludes individual promo emails and campaign emails.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Emails</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#email_id">email_id</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#email_template_id">email_template_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#from_contacts_id">from_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The individual from whom the mail was sent.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#to_contacts_id">to_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The individual to whom this email is sent.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#cc_contacts_id">cc_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The individual which is copied on this email.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#subject_str">subject_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The subject line of this email.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#html_body_txt">html_body_txt</A></td><td class="fielddata">TEXT</td><td class="fielddata">Yes</td><td class="fielddata">The body text of the email in HTML format; it is edited by the Flex RichTextEditor.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Emails_CcContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Emails_FromContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Emails_ToContact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">EmailTemplate_Emails</td><td class="fielddata">Non Identifying</td><td class="fielddata">EmailTemplate</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Emails_1</td><td class="fielddata">email_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Emails_2</td><td class="fielddata">email_template_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">html_body_txt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">email_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">email_template_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">from_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">to_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">subject_str</td></tr>
<tr><td class="fielddata">Emails_CcContact</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (cc_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Emails_FromContact</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (from_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Emails_ToContact</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (to_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">EmailTemplate_Emails</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (email_template_id) REFERENCES EmailTemplate(email_template_id)</td></tr>
<tr><td class="fielddata">PK_Emails</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (email_id)</td></tr>
</table>
<A NAME="EmailTemplate"></A>
<div class="objectname">Entity: EmailTemplate</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the set of email template 'specs' edited using the emails screen.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_EmailTemplate</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#email_template_id">email_template_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">A unique identifier for the email template.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#template_name">template_name</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The name of the template as it appears on the left side of the email screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#from_enm">from_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">The role of the individual from whom the emal is sent.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#to_enm">to_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">The role of the individual to whom the emal is sent.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cc_enm">cc_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata">The role of the individual copied on the emal is sent.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#subject_str">subject_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The subject of this email.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#body_HTML_txt">body_HTML_txt</A></td><td class="fielddata">TEXT</td><td class="fielddata">Yes</td><td class="fielddata">The HTML body of the email.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">EmailTemplate_Emails</td><td class="fielddata">Non Identifying</td><td class="fielddata">EmailTemplate</td><td class="fielddata">Emails</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_EmailTemplate_1</td><td class="fielddata">email_template_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">body_HTML_txt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">email_template_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">template_name</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">from_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">to_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">subject_str</td></tr>
<tr><td class="fielddata">PK_EmailTemplate</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (email_template_id)</td></tr>
</table>
<A NAME="EventParticipants"></A>
<div class="objectname">Entity: EventParticipants</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">Each events has its participants listed in this table.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_EventParticipants</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#event_id">event_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#participant_contacts_id">participant_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#rsvp_flg">rsvp_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">An indication whether this individual RSVPed for the event.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#addended_flg">addended_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">An indication whether this participants attended the event.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_contact_id">sponsor_contact_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">Some participants may be CAP candidates referred by a sponsor.  The RC for this CAP can be tracked trhough the sponsor Id.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#deposit_id">deposit_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">Records the deposit amount in case a deposit was made prior to joining the webinar.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#notes_str">notes_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">Notes applicable to this participant.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Deposits_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Deposits</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Events_EventParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Events</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsor_EventParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_EventParticipants_1</td><td class="fielddata">event_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_EventParticipants_2</td><td class="fielddata">participant_contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_EventParticipants_3</td><td class="fielddata">sponsor_contact_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">addended_flg</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">event_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">participant_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rsvp_flg</td></tr>
<tr><td class="fielddata">Contacts_EventParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (participant_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Deposits_EventParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (deposit_id) REFERENCES Deposits(deposit_id)</td></tr>
<tr><td class="fielddata">Events_EventParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (event_id) REFERENCES Events(event_id)</td></tr>
<tr><td class="fielddata">PK_EventParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (event_id)</td></tr>
<tr><td class="fielddata">Sponsor_EventParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_contact_id) REFERENCES Contacts(contacts_id)</td></tr>
</table>
<A NAME="Events"></A>
<div class="objectname">Entity: Events</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the centeral repository of all breakfast and networking events organized to support the APG Network building activities.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Events</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#event_id">event_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#date_dt">date_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#start_time_tm">start_time_tm</A></td><td class="fielddata">TIME</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#duration_tm">duration_tm</A></td><td class="fielddata">TIME</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#invitations_cnt">invitations_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#location_id">location_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#coordinator_contacts_id">coordinator_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#catering_contacts_id">catering_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#coordinator_rating_enm">coordinator_rating_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#facility_rating_enm">facility_rating_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#catering_rating_enm">catering_rating_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">CateringContact_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Coordinator_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Events_EventParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Events</td><td class="fielddata">EventParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Locations_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Locations</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Events_1</td><td class="fielddata">event_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Events_2</td><td class="fielddata">location_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">catering_contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">event_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">date_dt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">start_time_tm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">duration_tm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">location_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coordinator_contacts_id</td></tr>
<tr><td class="fielddata">CateringContact_Events</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (catering_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Coordinator_Events</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (coordinator_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Locations_Events</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (location_id) REFERENCES Locations(location_id)</td></tr>
<tr><td class="fielddata">PK_Events</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (event_id)</td></tr>
</table>
<A NAME="Leads"></A>
<div class="objectname">Entity: Leads</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a repository of all leads collected by the system.  This table is populated from uploaded lead files.  As a lead is created, it is linked to a contact in the contacts table.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Leads</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#lead_id">lead_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name_str">name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The name of the individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#phone_str">phone_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The last known phone number of this individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#address_str">address_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The last known address of this individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#email_str">email_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The last known email of this individual.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#SIC">SIC</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The last known SIC code for this individual.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Leads</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Leads</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Leads_1</td><td class="fielddata">lead_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Leads_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">address_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">lead_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">phone_str</td></tr>
<tr><td class="fielddata">Contacts_Leads</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Leads</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (lead_id)</td></tr>
</table>
<A NAME="Locations"></A>
<div class="objectname">Entity: Locations</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all locations breakfasts and networking meeting.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Locations</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#location_id">location_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name_str">name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The name of the location.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#street_address_str">street_address_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The location's streed address.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#ZIP_code">ZIP_code</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The location's ZIP code.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#driving_directions_URL_str">driving_directions_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">An automatically generated driving directions URL.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#website_URL_str">website_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The location's web-site.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#description_str">description_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">A description of the location, typically extracted from their web-site.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#image1_URL_str">image1_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">A 102x78 image of the location.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#image2_URL_str">image2_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">A 102x78 image of the location.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#image3_URL_str">image3_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">A 102x78 image of the location.</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Locations</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Locations</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Locations_Events</td><td class="fielddata">Non Identifying</td><td class="fielddata">Locations</td><td class="fielddata">Events</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_Locations</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Locations</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Locations_1</td><td class="fielddata">location_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Locations_2</td><td class="fielddata">ZIP_code</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">location_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">street_address_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">ZIP_code</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">driving_directions_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">image1_URL_str</td></tr>
<tr><td class="fielddata">Contacts_Locations</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Locations</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (location_id, contacts_id)</td></tr>
<tr><td class="fielddata">ZIP_Locations</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (ZIP_code) REFERENCES ZIP(ZIP_code)</td></tr>
</table>
<A NAME="MailingLists"></A>
<div class="objectname">Entity: MailingLists</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master repository of all campaign email lists used by the system.  The content of these lists is typically populated using the APGs.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_MailingLists</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#mailing_list_id">mailing_list_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#to_txt">to_txt</A></td><td class="fielddata">TEXT</td><td class="fielddata">Yes</td><td class="fielddata">This is a text field storing a semi-color seperated list of email addresses.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">MailingLists_Campaign</td><td class="fielddata">Non Identifying</td><td class="fielddata">MailingLists</td><td class="fielddata">Campaign</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_MailingLists_1</td><td class="fielddata">mailing_list_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">to_txt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">mailing_list_id</td></tr>
<tr><td class="fielddata">PK_MailingLists</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (mailing_list_id)</td></tr>
</table>
<A NAME="Markets"></A>
<div class="objectname">Entity: Markets</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">The master repository of all markets and their SIC codes.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Markets</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#market_id">market_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name_str">name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The official name of the SIC code.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#SIC_str">SIC_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The SIC code for this market.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Markets_PrimaryMarket</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">SynergesticMarkets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Markets_Sponsors_Markets</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">Sponsors_Markets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Markets_SynergesticMarkets</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">SynergesticMarkets</td><td class="fielddata">One Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Markets_1</td><td class="fielddata">market_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">SIC_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">market_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">name_str</td></tr>
<tr><td class="fielddata">PK_Markets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (market_id)</td></tr>
</table>
<A NAME="Packages"></A>
<div class="objectname">Entity: Packages</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">A repository of all packages supported by the system.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Packages</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#package_id">package_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#package_type_enm">package_type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#name_str">name_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The name of this package.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#parameter_int">parameter_int</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The parameter of this package, such as email count, testimonial count, etc.  The interpretation of this value depends on the type value.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cost_amt">cost_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The cost of this package.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Packages_Sponsors_Packages</td><td class="fielddata">Identifying</td><td class="fielddata">Packages</td><td class="fielddata">Sponsors_Packages</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Packages_1</td><td class="fielddata">package_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">cost_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">package_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">package_type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">name_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">parameter_int</td></tr>
<tr><td class="fielddata">PK_Packages</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (package_id)</td></tr>
</table>
<A NAME="RCs"></A>
<div class="objectname">Entity: RCs</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master list of all ASPs doing business with the APG network.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_RCs</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#rc_id">rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commision_rate_pct">commision_rate_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The commision rate in % for this RC.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cummulative_bonus_pct">cummulative_bonus_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The cummulative bonus percent for this RC.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cummulative_bonus_end_qtr_pct">cummulative_bonus_end_qtr_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The commulative bonus amount by end of the quarter.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#period_cutoff_day_of_month_int">period_cutoff_day_of_month_int</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The day of the month (e.g., 20th) by which commission and bonus amounts accumulate.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commission_paid_within_days_cnt">commission_paid_within_days_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of days after the cutoff by when the payment is to be rendered/</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sales_training_status_enm">sales_training_status_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">An indication whether this individual has attended and passed the training required for using the system.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sales_training_score_int">sales_training_score_int</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The scope of test presented at the end of the training webinar.  This field is required only of the training status is 'completed'.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sponsors_cnt">sponsors_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of sponsors signed up by this CAP.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#cap_cnt">cap_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The total number of caps signed up by this RC.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_systen_sales_amt">monthly_systen_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The monthly system sales from the previous most recent cutoff day.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_consulting_sales_amt">monthly_consulting_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The monthly consulting sales from the previous most recent cutoff day.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_usr_fees_amt">monthly_usr_fees_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The monthly user fees from the previous most recent cutoff day.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#quarter_system_sales_amt">quarter_system_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total system sales for the quarter.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#quarter_consulting_sales_amt">quarter_consulting_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total consulting sales for the quarter.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#quarter_user_fees_sales_amt">quarter_user_fees_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total user fees for the quarter.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_system_sales_amt">total_system_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total system sales since the RC signed up with APG Network.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_consulting_sales_amt">total_consulting_sales_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total consulting sales since the RC signed up with APG Network.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_user_fees_amt">total_user_fees_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total user fees since the RC signed up with APG Network.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_commissions_due_amt">total_commissions_due_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The total commissions due since RC signed with APG Network</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_bonus_due_amt">total_bonus_due_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">Total bonus amount due since the RC signed wqith APG Network.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#ytd_commissions_paid_amt">ytd_commissions_paid_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">Year to date commissions paid from Jan 1st; this amount is used for TAX purposes.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#ytd_bonus_paid_amt">ytd_bonus_paid_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">Year to date bonus amount paid from Jan 1st; this amount is used for TAX purposes.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#commission_balance_amt">commission_balance_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The remaining commission ballance applicable for this pay pariod until the cutoff day; this amount is used for generating the RC's statement.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#bonus_balance_amt">bonus_balance_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The remaining bonus balance applicable for this pay period until the cutoff day; this amount is used for generating the RC's statement.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#open_appointments_cnt">open_appointments_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of open or pending appointments for this RC.  This value changes daily.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#on_hold_cnt">on_hold_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of on-hold appointments for this RC.  This value changes daily.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ASP_first_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ASP_second_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ASP_third_RC</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">ASPs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_RCs</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">RCs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">RCs_Appointments</td><td class="fielddata">Non Identifying</td><td class="fielddata">RCs</td><td class="fielddata">Appointments</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">RCs_RC_Region</td><td class="fielddata">Identifying</td><td class="fielddata">RCs</td><td class="fielddata">RC_Region</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_RCs_1</td><td class="fielddata">rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_RCs_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">on_hold_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rc_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">commision_rate_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">cummulative_bonus_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">cummulative_bonus_end_qtr_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">period_cutoff_day_of_month_int</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">commission_paid_within_days_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sales_training_status_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsors_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_systen_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_consulting_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_usr_fees_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">quarter_system_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">quarter_consulting_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">quarter_user_fees_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_system_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_consulting_sales_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_user_fees_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_commissions_due_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_bonus_due_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">ytd_commissions_paid_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">ytd_bonus_paid_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">commission_balance_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">bonus_balance_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">open_appointments_cnt</td></tr>
<tr><td class="fielddata">Contacts_RCs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_RCs</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (rc_id)</td></tr>
</table>
<A NAME="RC_Region"></A>
<div class="objectname">Entity: RC_Region</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">The region associated with an RC is specified using this table.  It is, essentially, a many to many relationship between RCs and ZIP codes.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_RC_Region</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#rc_id">rc_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#ZIP_code">ZIP_code</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">RCs_RC_Region</td><td class="fielddata">Identifying</td><td class="fielddata">RCs</td><td class="fielddata">RC_Region</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_RC_Region</td><td class="fielddata">Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">RC_Region</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_RC_Region_1</td><td class="fielddata">rc_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_RC_Region_2</td><td class="fielddata">ZIP_code</td><td class="fielddata"></td><td class="fielddata"></td></tr>
<tr><td class="fielddata">IDX_RC_Region_3</td><td class="fielddata">rc_id, ZIP_code</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">ZIP_code</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rc_id</td></tr>
<tr><td class="fielddata">PK_RC_Region</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (rc_id, ZIP_code)</td></tr>
<tr><td class="fielddata">RCs_RC_Region</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (rc_id) REFERENCES RCs(rc_id)</td></tr>
<tr><td class="fielddata">ZIP_RC_Region</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (ZIP_code) REFERENCES ZIP(ZIP_code)</td></tr>
</table>
<A NAME="Redemptions"></A>
<div class="objectname">Entity: Redemptions</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all outstanding and redeemed coupons.  A record is added to this table each and every time a coupon email is sent out.  Coupons can be sent out as part of an email campaign.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Redemptions</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#coupon_instance_id">coupon_instance_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The serial number of this coupon.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#coupon_id">coupon_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The specification of this coupon.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#prospect_contacts_id">prospect_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The individual to which this coupon was sent.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sent_dtm">sent_dtm</A></td><td class="fielddata">DATETIME</td><td class="fielddata">Yes</td><td class="fielddata">The date and time this coupon was sent via email.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#redeemed_dtm">redeemed_dtm</A></td><td class="fielddata">DATETIME</td><td class="fielddata">No</td><td class="fielddata">The date and time this coupon was redeemd.  This field is populated if and only if the coupon was redeemed.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#approved">approved</A></td><td class="fielddata">BOOL</td><td class="fielddata">No</td><td class="fielddata">This flag is true when the coupon validation was approved by the sponsor/cap.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Redemptions</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Redemptions</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Coupons_Redemptions</td><td class="fielddata">Non Identifying</td><td class="fielddata">Coupons</td><td class="fielddata">Redemptions</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Redemptions_1</td><td class="fielddata">coupon_instance_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Redemptions_2</td><td class="fielddata">coupon_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Redemptions_3</td><td class="fielddata">prospect_contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sent_dtm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coupon_instance_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">coupon_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">prospect_contacts_id</td></tr>
<tr><td class="fielddata">Contacts_Redemptions</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (prospect_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Coupons_Redemptions</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (coupon_id) REFERENCES Coupons(coupon_id)</td></tr>
<tr><td class="fielddata">PK_Redemptions</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (coupon_instance_id)</td></tr>
</table>
<A NAME="Referrals"></A>
<div class="objectname">Entity: Referrals</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all referrals.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Referrals</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#referral_id">referral_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The repository of all referrals entering the system.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#referee_contact_id">referee_contact_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The individual making the referral.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#referred_by_contacts_id">referred_by_contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">No</td><td class="fielddata">The business being referred.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_date_dt">referral_date_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata">The date the referral was made.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_method_enm">referral_method_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">How was this referral obtained.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#referral_notes_str">referral_notes_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">Additional information about the referral, and referee, in free text form.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Referee_Contact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Referrals</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Referred_Contact</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Referrals</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Referrals_1</td><td class="fielddata">referral_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Referrals_2</td><td class="fielddata">referee_contact_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Referrals_3</td><td class="fielddata">referred_by_contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_method_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referee_contact_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">referral_date_dt</td></tr>
<tr><td class="fielddata">PK_Referrals</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (referral_id)</td></tr>
<tr><td class="fielddata">Referee_Contact</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (referee_contact_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Referred_Contact</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (referred_by_contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
</table>
<A NAME="SonsorRolodex"></A>
<div class="objectname">Entity: SonsorRolodex</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">These are the business associated of the sponsor.  They are populated using the 'business associates' panel in the  APG editor.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_SonsorRolodex</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#market_id">market_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_SonsorRolodex</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">SonsorRolodex</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_SonsorRolodex</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">SonsorRolodex</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_SonsorRolodex_1</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_SonsorRolodex_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">market_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata">Contacts_SonsorRolodex</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_SonsorRolodex</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (sponsor_id, contacts_id)</td></tr>
<tr><td class="fielddata">Sponsors_SonsorRolodex</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
</table>
<A NAME="Sponsors"></A>
<div class="objectname">Entity: Sponsors</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">An indication whether this is an approved Sponsor or Cap. </td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Sponsors</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#sponsor_type_enm">sponsor_type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#approved_flg">approved_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">An indication whether this is an approved Sponsor or Cap.  Upon approval, the Sponsor is provided a login to access their UCP.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_monthly_ad_costs_amt">total_monthly_ad_costs_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The sum of all monthly costs entered in the advertising analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_monthly_customers_generated_cnt">total_monthly_customers_generated_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The sum of the customers generated for each advertising method in the advertizing analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#average_product_cost_amt">average_product_cost_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The average product cost as entered in the advertising analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#average_sale_amt">average_sale_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The average sale amount as entered in the advertising analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_revenue_amt">total_revenue_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The calculated total revenue amount.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_repeat_customers_cnt">monthly_repeat_customers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The monthly repeat customers as entered from the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_referred_customers_cnt">monthly_referred_customers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">Monthly referred customers as entered from the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#widh_incentive_would_refer_pct">widh_incentive_would_refer_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">With referral, what percent would refer, as entered in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_participating_referee_customers_cnt">monthly_participating_referee_customers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">Monthly participating referee customers as entered in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#how_many_they_refer_back_cnt">how_many_they_refer_back_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">How many would they refer back, as entered in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#potential_C2C_referred_customers_cnt">potential_C2C_referred_customers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The potential C2C referred customers as calculated for the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#average_walking_per_day_cnt">average_walking_per_day_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The average number of walkins per day, as entered in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#average_clicks_per_offer_pct">average_clicks_per_offer_pct</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The assumed average click percent per offer, as entered in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_potential_B2C_referred_customers_cnt">total_potential_B2C_referred_customers_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The total potential B2C referred customers, as calculated in the referral analysis screen.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#first_deposit_amt">first_deposit_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata">The first deposit made on behalf of this sponsor.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#total_rebates_amt">total_rebates_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata">The total rebates due to this sponsor; only applicable when the an APG is complete.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#account_ballance_amt">account_ballance_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata">The account ballance for this sponsor.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#packages_sold_amt">packages_sold_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">No</td><td class="fielddata">The total amount attributed to packages sold to this sponsor.l</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">APG_Cap1</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap2</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap3</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap4</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap5</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap6</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap7</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap8</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Cap9</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">APG_Sponsor</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">APGs</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Contacts_Sponsors</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Sponsors</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Coupons</td><td class="fielddata">Non Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Coupons</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_SonsorRolodex</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">SonsorRolodex</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_AdvertizingMethods</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_AdvertizingMethods</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Markets</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_Markets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Packages</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_Packages</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Sponsors_1</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Sponsors_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_potential_B2C_referred_customers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">approved_flg</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_monthly_ad_costs_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_monthly_customers_generated_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">average_product_cost_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">average_sale_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">total_revenue_amt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_repeat_customers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_referred_customers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">widh_incentive_would_refer_pct</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_participating_referee_customers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">how_many_they_refer_back_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">potential_C2C_referred_customers_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">average_walking_per_day_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">average_clicks_per_offer_pct</td></tr>
<tr><td class="fielddata">Contacts_Sponsors</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Sponsors</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (sponsor_id)</td></tr>
</table>
<A NAME="Sponsors_AdvertizingMethods"></A>
<div class="objectname">Entity: Sponsors_AdvertizingMethods</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">The monthly cost that the sponsor incurrs for this advertising method.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Sponsors_AdvertizingMethods</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#advertizing_method_id">advertizing_method_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#monthly_cost_amt">monthly_cost_amt</A></td><td class="fielddata">FLOAT</td><td class="fielddata">Yes</td><td class="fielddata">The monthly cost that the sponsor incurrs for this advertising method.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#customers_generated_cnt">customers_generated_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of new customers generated monthly with this method.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">AdvertizingMethods_Sponsors_AdvertizingMethods</td><td class="fielddata">Identifying</td><td class="fielddata">AdvertizingMethods</td><td class="fielddata">Sponsors_AdvertizingMethods</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_AdvertizingMethods</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_AdvertizingMethods</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Sponsors_AdvertizingMethods_1</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Sponsors_AdvertizingMethods_2</td><td class="fielddata">contacts_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">customers_generated_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">advertizing_method_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">monthly_cost_amt</td></tr>
<tr><td class="fielddata">AdvertizingMethods_Sponsors_AdvertizingMethods</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (advertizing_method_id) REFERENCES AdvertizingMethods(advertizing_method_id)</td></tr>
<tr><td class="fielddata">PK_Sponsors_AdvertizingMethods</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (sponsor_id, contacts_id, advertizing_method_id)</td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_AdvertizingMethods</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
</table>
<A NAME="Sponsors_Markets"></A>
<div class="objectname">Entity: Sponsors_Markets</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Sponsors_Markets</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#market_id">market_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Markets_Sponsors_Markets</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">Sponsors_Markets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Markets</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_Markets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">market_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata">Markets_Sponsors_Markets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (market_id) REFERENCES Markets(market_id)</td></tr>
<tr><td class="fielddata">PK_Sponsors_Markets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (sponsor_id, market_id)</td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Markets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
</table>
<A NAME="Sponsors_Packages"></A>
<div class="objectname">Entity: Sponsors_Packages</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">These are the packages each sponsor signed up for.  It is a many-to-many mapping between sponsors and packages.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Sponsors_Packages</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#sponsor_id">sponsor_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#package_id">package_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Packages_Sponsors_Packages</td><td class="fielddata">Identifying</td><td class="fielddata">Packages</td><td class="fielddata">Sponsors_Packages</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Packages</td><td class="fielddata">Identifying</td><td class="fielddata">Sponsors</td><td class="fielddata">Sponsors_Packages</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_Sponsors_Packages_1</td><td class="fielddata">sponsor_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
<tr><td class="fielddata">IDX_Sponsors_Packages_2</td><td class="fielddata">sponsor_id, package_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">package_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">sponsor_id</td></tr>
<tr><td class="fielddata">Packages_Sponsors_Packages</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (package_id) REFERENCES Packages(package_id)</td></tr>
<tr><td class="fielddata">PK_Sponsors_Packages</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (sponsor_id, package_id)</td></tr>
<tr><td class="fielddata">Sponsors_Sponsors_Packages</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (sponsor_id) REFERENCES Sponsors(sponsor_id)</td></tr>
</table>
<A NAME="Statements"></A>
<div class="objectname">Entity: Statements</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is the master table of all statements available to users.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Statements</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#statement_id">statement_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">A unique identifier of the statement.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#XML_txt">XML_txt</A></td><td class="fielddata">TEXT</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#period_start_dt">period_start_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#period_end_dt">period_end_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#PDF_blb">PDF_blb</A></td><td class="fielddata">BLOB</td><td class="fielddata">No</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Statements</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Statements</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">period_end_dt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">statement_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">XML_txt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">period_start_dt</td></tr>
<tr><td class="fielddata">Contacts_Statements</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Statements</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (statement_id)</td></tr>
</table>
<A NAME="SynergesticMarkets"></A>
<div class="objectname">Entity: SynergesticMarkets</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">A list of synergestic markets for each SIC code.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_SynergesticMarkets</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#market_id">market_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#syn_market_id">syn_market_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata"></td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Markets_PrimaryMarket</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">SynergesticMarkets</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Markets_SynergesticMarkets</td><td class="fielddata">Identifying</td><td class="fielddata">Markets</td><td class="fielddata">SynergesticMarkets</td><td class="fielddata">One Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_SynergesticMarkets_1</td><td class="fielddata">market_id</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">syn_market_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">market_id</td></tr>
<tr><td class="fielddata">Markets_PrimaryMarket</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (market_id) REFERENCES Markets(market_id)</td></tr>
<tr><td class="fielddata">Markets_SynergesticMarkets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (syn_market_id) REFERENCES Markets(market_id)</td></tr>
<tr><td class="fielddata">PK_SynergesticMarkets</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (market_id, syn_market_id)</td></tr>
</table>
<A NAME="WebinarParticipants"></A>
<div class="objectname">Entity: WebinarParticipants</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">The subject webinar.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_WebinarParticipants</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#webinar_id">webinar_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The subject webinar.</td></tr>
<tr><td class="fielddata">PK,FK</td><td class="fielddata"><A HREF="attrd.html#contacts_id">contacts_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The participant's contact information.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#rsvp_flg">rsvp_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">This flag is true if the participant RSVPed.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#attended_flg">attended_flg</A></td><td class="fielddata">BOOL</td><td class="fielddata">Yes</td><td class="fielddata">This flag is true if the participant attended.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#deposit_id">deposit_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">Records the deposit amount in case a deposit was made prior to joining the webinar.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#notes_str">notes_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">Notes applicable to this participant.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_WebinarParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Deposits_WebinarParticipants</td><td class="fielddata">Non Identifying</td><td class="fielddata">Deposits</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Webinars_WebinarParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Webinars</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">deposit_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">webinar_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">contacts_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rsvp_flg</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">attended_flg</td></tr>
<tr><td class="fielddata">Contacts_WebinarParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (contacts_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">Deposits_WebinarParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (deposit_id) REFERENCES Deposits(deposit_id)</td></tr>
<tr><td class="fielddata">PK_WebinarParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (webinar_id, contacts_id)</td></tr>
<tr><td class="fielddata">Webinars_WebinarParticipants</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (webinar_id) REFERENCES Webinars(webinar_id)</td></tr>
</table>
<A NAME="Webinars"></A>
<div class="objectname">Entity: Webinars</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a master repository of all webinar instances.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_Webinars</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#webinar_id">webinar_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">This is the master repository of all webinar instances.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#date_dt">date_dt</A></td><td class="fielddata">DATE</td><td class="fielddata">Yes</td><td class="fielddata">The date this webinar takes place.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#start_time_tm">start_time_tm</A></td><td class="fielddata">TIME</td><td class="fielddata">Yes</td><td class="fielddata">The webinar's start time.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#duration_tm">duration_tm</A></td><td class="fielddata">TIME</td><td class="fielddata">Yes</td><td class="fielddata">The expected duration for this webinar.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#type_enm">type_enm</A></td><td class="fielddata">ENUM</td><td class="fielddata">Yes</td><td class="fielddata">This indicates whether it is a Tue, Thu, Sat webinar, Spanish or Other webinar.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#invitations_cnt">invitations_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of invitations sent out.  There is no limit to the number of participants because there is not physical room with limited capacity.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#rsvp_cnt">rsvp_cnt</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The number of RSVPs recieved.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#meeting_URL_str">meeting_URL_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The URL to the Webex or GoToMeeting location.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#meeting_pwd_str">meeting_pwd_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The password for the online meeting used to present the webinar.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#call_in_number_str">call_in_number_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The telecon call in number.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#call_in_passcode_str">call_in_passcode_str</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The telecon passcode.</td></tr>
<tr><td class="fielddata">FK</td><td class="fielddata"><A HREF="attrd.html#instructor_contact_id">instructor_contact_id</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">The contact information of the instructor.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">Contacts_Webinars</td><td class="fielddata">Non Identifying</td><td class="fielddata">Contacts</td><td class="fielddata">Webinars</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">Webinars_WebinarParticipants</td><td class="fielddata">Identifying</td><td class="fielddata">Webinars</td><td class="fielddata">WebinarParticipants</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">instructor_contact_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">webinar_id</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">date_dt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">start_time_tm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">duration_tm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">type_enm</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">invitations_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">rsvp_cnt</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">meeting_URL_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">meeting_pwd_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">call_in_number_str</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">call_in_passcode_str</td></tr>
<tr><td class="fielddata">Contacts_Webinars</td><td class="fielddata">Table Constraint</td><td class="fielddata">Foreign Key</td><td class="fielddata">FOREIGN KEY (instructor_contact_id) REFERENCES Contacts(contacts_id)</td></tr>
<tr><td class="fielddata">PK_Webinars</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (webinar_id)</td></tr>
</table>
<A NAME="ZIP"></A>
<div class="objectname">Entity: ZIP</div>
<div class="details">Entity details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata">This is a collection of all ZIP codes in the nation.  It is used to associated contacts with cities, counties and states.  and associated RCs with their region.</td></tr>
<tr><td class="fieldname">Primary key constraint name</td><td class="fielddata">PK_ZIP</td></tr>
</table>
<div class="details">Attributes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Key</td><td class="fieldname">Attribute name</td><td class="fieldname">Data type</td><td class="fieldname">Not null</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">PK</td><td class="fielddata"><A HREF="attrd.html#ZIP_code">ZIP_code</A></td><td class="fielddata">INTEGER</td><td class="fielddata">Yes</td><td class="fielddata">This is the unique ZIP code as designated by the USPS.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#City">City</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The city within which this ZIP code resides.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#County">County</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">No</td><td class="fielddata">The county within which this ZIP code resides.</td></tr>
<tr><td class="fielddata"></td><td class="fielddata"><A HREF="attrd.html#State">State</A></td><td class="fielddata">VARCHAR</td><td class="fielddata">Yes</td><td class="fielddata">The state within this ZIP code resides.</td></tr>
</table>
<div class="details">Relationships:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Relationship name</td><td class="fieldname">Type</td><td class="fieldname">Parent</td><td class="fieldname">Child</td><td class="fieldname">Cardinality</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata">ZIP_Contacts</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Contacts</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_Deposits</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Deposits</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_Locations</td><td class="fielddata">Non Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">Locations</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
<tr><td class="fielddata">ZIP_RC_Region</td><td class="fielddata">Identifying</td><td class="fielddata">ZIP</td><td class="fielddata">RC_Region</td><td class="fielddata">Zero Or More</td><td class="fielddata"></td></tr>
</table>
<div class="details">Indexes:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Index name</td><td class="fieldname">Index columns</td><td class="fieldname">Type</td><td class="fieldname">Sort order</td></tr>
<tr><td class="fielddata">IDX_ZIP_1</td><td class="fielddata">ZIP_code</td><td class="fielddata"></td><td class="fielddata">ASC</td></tr>
</table>
<div class="details">Constraints:</div>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Constraint name</td><td class="fieldname">Type</td><td class="fieldname">Level</td><td class="fieldname">Constraint</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">State</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">ZIP_code</td></tr>
<tr><td class="fielddata"></td><td class="fielddata">Column Constraint</td><td class="fielddata">Not Null</td><td class="fielddata">City</td></tr>
<tr><td class="fielddata">PK_ZIP</td><td class="fielddata">Table Constraint</td><td class="fielddata">Primary Key</td><td class="fielddata">PRIMARY KEY (ZIP_code)</td></tr>
</table>
</td>
</tr>
</table>
</body>
</html>
